Skip to main content

🔍 Get Record

The Get Record action allows you to retrieve specific records from a database table based on selected filters and criteria.

Configuration​

  • Name: Enter a descriptive name for this Get Record action.
  • Select Source: Choose the data source or connection from which to retrieve the record.
  • Select Table: Specify the table from which to fetch the record.
  • Select Columns: Select one or more columns to be retrieved from the table.
  • Filter: Apply one or more filter conditions to narrow down the records returned.
    • Use the Filter button to add filtering criteria.
    • Add or remove filters using the plus (+) and delete (x) buttons.
    • Define filter conditions based on column values and comparison operators.

Features​

  • Fetches specific records from a table with optional column selection.
  • Supports complex filtering to retrieve precise data.
  • Enables retrieval of data for use in subsequent workflow steps.
  • Integrates with multiple data sources.

Use Cases​

  • Retrieve user details based on ID or email.
  • Fetch order or transaction data for processing.
  • Query configuration or settings from a database.
  • Extract specific records for decision-making or reporting.

Notes​

  • Ensure the selected source and table exist and are accessible.
  • Choose columns carefully to optimize query performance.
  • Use filters to avoid retrieving unnecessary data.

Tip: Combine Get Record with other data actions like Filter array or Select to manipulate and utilize retrieved data efficiently.